Payroll Analysis reports

These reports are designed for payroll budget analysis.

Access the reports in Axiom Assistant

If you do not have administrative user permissions, access the reports using the following path:

Main > Navigation > Explorer > Libraries > Reports Library > Budgeting Reports > Payroll Analysis.

NOTE: For additional instructions, see Browse the Report Library.

If you have administrative user permissions, access the report using the following path:

Admin > Admin Task Panes > Budget Admin > Budget Reporting >  Budget Analysis > Payroll Analysis.

The system pulls Current YTD Actual hour and dollar data from the ACT_Pay27_YYYY table based on the YTD Payroll Period setting in the 01 Configuration Driver. It uses the YTD Period to keep the Payroll Period static and calculate the Remaining Current Year Projected values by determining the number periods left in the current year.

The system saves current YTD Actuals (YTDFTE) and Remaining Projected (RemFTE) data in the following year's Bud_Pay12 tables to preserve the Payroll period settings when the budget plan files are built.

FTE Additions and Changes by Jobcode

Use to review the FTE summary by department by JobCode, highlighting changes made to the projected year and budget in the plan files.

FTEs by Department

Use to review the FTE summary by department, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget.

FTEs by Department by Jobcode

Use to review FTE report by department by job code, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget.

FTEs by Jobcode

Use to review the FTE report by job code, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget.

Monthly FICA by Department

Use to show monthly total FICA expense by department for both current-year projected and next-year budget. Monthly expense shows for next-year budget. Designed for use by clients who budget FICA in a central department or to review the overall monthly spread of FICA expense.

Monthly FTE Target Variance by Department

Use to review a department summary of the FTE variance by month for next year’s budget to the department target.

Monthly FTEs by Department

Use to review a department summary of total FTEs by month for next year’s budget. Designed to be used to review the monthly spread of total FTEs as well as by department.

NYB Hours and Dollars by Employee

Use to review hours and dollars by employee, job code, pay type, and department. To use this report, the department must use the employee labor option in plan files.

Worked Hours Per Unit By Department by Jobcode

Use to compare the projected and NY Budget by Provider to the current year by selected DataType.